create external table if not exists jms_ods.es_login_log (
   id            bigint     comment'雪花id'
  ,userid        string     comment'用户id'
  ,usercode      string     comment'用户编码'
  ,username      string     comment'用户名称'
  ,networkid     string     comment'网点id'
  ,networkcode   string     comment'用户编码'
  ,networkname   string     comment'用户名称'
  ,logintype     string     comment'登录端(1:web、2:pc、3:app)'
  ,apptype       string     comment'应用类型(1:jms、2:jms-pc、3:内场app、4:外场app、5:站点app、6:jms-app)'
  ,logintime     string     comment'登录时间'
  ,loginstatus   string     comment'登录状态failsuccess'
  ,ip            string     comment'登录ip'
  ,ipcity        string     comment'登录ipcity'
  ,mac           string     comment'mac地址'
  ,remark        string     comment'备注'
  ,createtime    string     comment'创建时间'
  ,traceid       string     comment'事务id"'
)comment '员工登录日志表'
partitioned by (dt string comment '分区日期')
stored as parquet
location '/dw/hive/jms_ods.db/external/es_login_log'
tblproperties (
'discover.partitions'='false',
'parquet.column.index.access'='true'
);
